Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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