Sample input CSV, it is comma seperated
code1 |
code2 |
code3 |
1002 |
2001 |
1003 |
1003 |
1002 |
1002 |
Expected output. i.e table in ax has two fields like codegroup and code.
codegroup |
code |
code1 |
1002 |
code1 |
1003 |
code2 |
2001 |
code2 |
1002 |
code3 |
1003 |
i need to write a job,
when i tried, i can able to fetch records in csv 1st column only but not 2nd,3rd columns, i am using a container to store values from csv.
lkustb
2
You probably have to attach the code here.
ttsbegin;
while(filerow.status() == IO_STATUS::OK)
{
con = filerow.read();
//con1 = filerow.read();
//readCon = str2Con(tb.nextToken(true));
cols = conLen(con);
numlines = tb.numlines();
while (x<=cols)//for(x=1; x <= cols; x++)
{
header = conPeek(con,x);
while(i<=numlines)
{
//con1 =con;
con1 =filerow.read();
table.Field1 = conPeek(con1,x);
//table.Field2 = conPeek(con1,x)
info(strFmt("%1- - %2",header,table.Field1));
i++;
}
con1 = text
i=2;
x++;
}
}
ttscommit;