Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
today i repost my probleme that i didnt solve
Problem : i want to show the dimensions of my straight table only if that respect a condition
Exemple : my complete table
the solution was make a calculated dimesnion in a new table with this syntaxe : if (wildmatch(BD, 'ML', 'KL', 'BL'), [Nom])
And its work great, but its a performance killer,
Somebedy Know i to do that directly in the script load? so that i load only want i want (may be in a new table)
i join the files on this post
Thanks
Create field in load script as
load *,
if(wildmatch(BD, 'ML', 'KL', 'BL'), [Nom])) as Nom_New
From Table
Now use Nom_new in the dimension of your chart
If You want to filter the data in the load script, then you can do it with "Where" in the load script.
LOAD
*
FROM/Resident
Where Wildmatch(BD, 'ML', 'KL', 'BL')
Hope this helps.
Create field in load script as
load *,
if(wildmatch(BD, 'ML', 'KL', 'BL'), [Nom])) as Nom_New
From Table
Now use Nom_new in the dimension of your chart