Join specific cell as column

[tamilarasu]

Hi,

I want to join a specific cell value as column in a table.  Please see the below screenshot for better understanding.

Input data

What I need - Output

Is this possible in load script?

Thanks in advance.

Kind Regards,

Tamil

[prma7799]

Hi Nagraj,

Can you post some sample data?

Thanks

PM

[tamilarasu]

Hi prasahant,

Attached.

[prma7799]

PFA

[Anonymous · Accepted solution]

This method is dynamic.

LOAD Sno,

     Cust,

     Prod,

     [Sold Qty],

     Price

FROM

[Sample.xlsx]

(ooxml, embedded labels, header is 2 lines, table is Sheet1);

Join

First 1

LOAD

     B as Country

FROM

[Sample.xlsx]

(ooxml, no labels, table is Sheet1);

[robert_mika]

tab1:

LOAD

Sno,

  Cust,

  Prod,

  [Sold Qty],

  Price

FROM

Sample.xlsx

(ooxml, embedded labels, header is 2 lines, table is Sheet1);

tab2:

LOAD

     B as Country

FROM

Sample.xlsx

(ooxml, explicit labels, table is Sheet1)

WHERE RecNo() =1

[tamilarasu]

Hi prasahant,

Thanks. But I have around 100 files., so I can't hard code the country name each time.

[tamilarasu]

Thank you so much All.