I have data in Excel, records wise (Row wise)
we need data in the below format .I mean to say we need in a single format with comma deliminator .
Could you pls suggest me the better solution
Load * inline [
Front -end exp (in a text box) : =Concat (Country, ',')
Or in the script like this:
Load * Inline [
LOAD Concat(Distinct Country, ', ', RecNo()) as ConcatCountry
Retrieving data ...