Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Cross table

Hi all,

I have problem in loading these excel sheet

Help me out.

PFA

Regards,

Joshua.

2 Replies
Anil_Babu_Samineni

Your Expected O/P

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bharath28
Creator
Creator

Hi Joshua,

I think you don't need cross table here.

I see that the structure is same in every sheet in the excel file, so you need to concatenate them.

Use the for loop to loop into each sheet and create a date column.

Load Multiple excel sheets using For loop