Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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