Table header

Help Studio
, ,
1

I’m sharing a sample excel here, In cell N1 I’m mentioning the table header name, In “sheet4” table header name is not available in such cases the pervious sheets (“Sheet3”)header name has to be used.
SampleExcel_TableName.xlsx (12.0 KB)
Can any one please help me to solve this issue

2

Hi @Chippy_Kolot ,

Sheet 3 headers to be clone and assigned to sheet4.

In assign activity
DT_sheet4 = DT_sheet3.clone

Thanks,
Muthuraj

3

If it happens in sheet7 or 8 …? we cant predict in which sheet it will happens.

4

Hey!

Use Build data table and create the columns…

Read the Excels and dump the data to temp(Build) data table that’s it.

Regards,
NaNi