Hi I have set the ColumnName but still I am getting an error as "Lookup Data Table : In The Lookup Column category the value for argument Column Name is not set or is invalid
can anyone suggest where i am going wrong
Copy the column name from excel and paste it in activity and try. If not works, then pass the Column index in the Column Index field in properties. this will works.
Sorry for mu ignorance what should I pass as column index?
The header of the input file (.txt) is
TAX_TYPE,TAX_RATE,TAX_FIXED
Give 0 in the Column Index… @dipon1112000
Hope it helps!!
Correct me if I have understood you right?
input file has header
TAX_TYPE,TAX_RATE,TAX_FIXED
And I have 2 Lookup Data Table
- So the First Lookup Data Table was supposed to look for TAX_TYPE and you want me to add 0 to column index then what should I add for second Lookup data table which is supposed to look for TAX_RATE
The indexing start from 0,1 ,2
First column means=0
Second column means=1…
You can check the column name and give accordingly.
Use ‘Write CSV’ for dt2 to check what’s inside.
No column name ‘TAX_RATE’ exists in dt2 according to the error message.
Thank you for your help but that is strange as it was working before and I am reading the second input file as read CSV (this was working before)
I have just introduced first input file as .txt instead of CSV
If the patterns between the txt and csv are same, there should be no problem.
Otherwise, you may need adjustment according to the input file.
I got the problem but don’t know how to fix it. Read CSV is getting converted
This is input file .txt which I am reading as CSV
And this is what I am getting in write CSV
All the columns are getting converted to 1 column
I.e TAX_TYPE,TAX_RATE,TAX_FIXED is getting converted to (“TAX_TYPE,TAX_RATE,TAX_FIXED”)
Anyone has any idea , 
Please check your ‘Read CSV’.
I guess the Delimiter is not set as Comma.
Thank you 
it worked but now I am getting another error
Assign: there is no row at position -1
I am using assign activity to assign Fixed Rate to dt1
Can you advise how to overcome this
That means the value of dt2RowIndex is -1.
Please check where it’s assigned. I assume it comes from the lookup data table. Then it means no value is found in the lookup data table, or something is setting incorrectly.
Ya it’s coming from Lookup data table which has
Input as Dt2
Lookup value is out
ColumnName is “TAX_TYPE”
Output is dt2RowIndex
And input file has got data
Got it fixed thank you
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.