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: 
saumyashah90
Specialist
Specialist

Dynamic Field Name reading in Table


i have a table

Header 1Header 2Header 3Header 4
adgj
behk
cfil

Now before if i have is Header1 ,Header2 and Header3

i read it from excel and show it on UI

on Table Box/Straight Table/Pivot Table

Now if Header4 is added

It should dynamically get read from the excel and also in UI

i.e on TableBox/Straight Table/Pivot Table on wither of this it should read that column dynamic

How can that be done?

8 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi Saumya,

You can read all the column in the excel file dynamically by just putting LOAD *, but it is not possible to dynamcially add new columns in straight table or table box.  Need some macro to execute to add the columns to the table while opening the dashboard.

Regards,

Jagan.

saumyashah90
Specialist
Specialist
Author

you know i tried this

I made cross table out of it

for

1.png

i got

1.png

Can any one help me in fixing this to normal output in straight table or Pivot Table

saumyashah90
Specialist
Specialist
Author

any one?

Not applicable

Will you post sample app

saumyashah90
Specialist
Specialist
Author

that is the input given in first image

That all i have in application


CELAMBARASAN
Partner - Champion
Partner - Champion

To dynamically show you dont want to make it to normal table.

You could possibly check with Pivot Table Drag and change the axis of the dimension(Pivoting).

Drag

Drag.PNG.png

Result:

Result.PNG.png

saumyashah90
Specialist
Specialist
Author

yeah i tried it

Can you please try with the given input?

kedar_dandekar
Creator
Creator

Hi Saumya,


I tried this, and it seems to work, however I had to add a column for 'Row Num' to identify each row uniquely

Check out the attached qvw..

- KD