connection

[dnowebdn]

Test the connection

[sunny_talwar]

Try this

Table:
LOAD ID, 
     Type, 
     Concat(Jobtype, ' & ') as Jobtype, 
     Concat(Ration, ' & ') as Ration
FROM
[..\..\Downloads\TestFlow.xlsx]
(ooxml, embedded labels, table is Sheet2)
Group By ID, Type;

[dnowebdn]

Any help