Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am loading data from Script Editor Like below.
AB1:
Load
a,
b,
c
from (Source);
The issue is ,my datamodel looks something like below:
AB1:
AB1.a
AB1.b
AB1.c
Where as I only want my table to have only column names instead of table name.column name.
Thank you for the help.
Thanks,
Alva.
or post a small example of your csv file
Hi there,
I got the same issue but I was able to resolve by doing this. Hope this helps some one
Let vTableName = 'AB1';
For fieldIdx = 1 to NoOfFields('$(vTableName)')
LET vFieldname = FieldName($(fieldIdx), '$(vTableName)');
LET vFieldname1 = SubField(FieldName($(fieldIdx), '$(vTableName)'),'.',2);
RENAME Field [$(vFieldname)] TO [$(vFieldname1)];
Next fieldIdx
Thanks
Prakash