Conditional display of columns using disconnected table

[YoussefBelloum]

Hi Guys,

Hope you all doing well.

I need to hide/display  columns (dimensions & expressions) of a table (simple or pivot) using values from a field in a disconnected table.

Here is a sample LOAD INLINE:

table1:
LOAD * Inline[
Code Garantie, Code Branche, Charge sinistre, Code produit
AS, BS, 10, A10
AC, BC, 20, A20
];

table2:
LOAD * Inline[
Etat sin, Code Branche, libelle branche, produit
Ouvert, BS, Test1, AABB
Ferme, BC, Test2, BBCC
];

Requetes:
LOAD * Inline[
Nom req, colonne
A, Code Garantie
A, Code Branche
A, Charge sinistre
B, Etat sin
B, Code Branche
B, produit
];

Values from field "colonne" of the "Requetes" table represents the fields names of the tables "Table1" and "Table2"..

When I select the value "A" of the field "Nom_req" in a filter pane, I need to display only the columns which have a name equal to the values of the field "colonne".. 

Example when I choose value "A" ==> columns need to be displayed are: Code Garantie, Code Branche, Charge sinistre

PS: Table "Requetes" needs to stay disconnected from other tables.

I'm thinking about p() function but I can't get it work

Let me know please

Thank you !

Youssef

[YoussefBelloum]

@sunny_talwar Could you take a look at this please ?

[sunny_talwar]

In an effort to save time, would you be able to share the sample you are working with?

[YoussefBelloum]

Hi Sunny,

I posted a load inline on the description above.

But I just found a solution to my problem actually, It is based on the ad-hoc technique.

Thank you, Take care !

[sunny_talwar]

Its good you found the solution, but for future reference. It is easier to work with a sample qvw or qvf because I don't have to load the data and create front end objects to check what you are trying to do. All those things will require me to spend time. Why not make it easier for people you are seeking help from? 

Best,
Sunny

[YoussefBelloum]

Sorry about that Mr. Next time you'll find everything you need.

Thanks

Youssef