Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
devrajR
Contributor III
Contributor III

Dynamic Columns in a Table in Sheets

Hello,

I have a scenario where I am using Generic Load to get data in the format as shown in the Image:

Sometimes, there will be a Col3 (Case 2), sometimes there won't be a Col3 (Case 1)

devrajR_0-1684409408688.png

 

In the table in Sheets, I want to show what ever columns are there in the load table. How do I hide Col3, when it's not in the load table OR how do I show all the columns that are in the load table?

 

Any suggestions would be helpful. 

 

Thanks,

Devraj

Labels (4)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I think you can:

1. Add Col3 to the table. 

2. Set a "Show column if" condition of "Count(Col3)"

-Rob