Discussion Board for collaboration related to QlikView App Development.
Hi I am searching for a solution for following problem.
I try to load only data where the 3rd field ist always F. If there is an entry with E it should skip all values for the material.
So in my example picutere i will only have material 1,2 and 5.
3 should be skipped because it is allways E (thats a simple where clause)
and 4 should be also skipped because one of the entrys is E
How can i do it?
from table name
where ThirdFieldName = 'F';
Load * Inline
F1, F2, F3
Load F1, MinString(F3) as MinFlag Resident Temp Group By F1;
Load F1, F2, F3
Where MinFlag = 'F';
Drop Table Temp;
where ThirdFieldName <> 'E';
//find the metrials to load
load distinct material As CheckValues
where not exists(CheckValues,material)
I understand you wanna keep data from original table where FirstFieldName has only entries with 'F' in original table.
Here's a way:
Load Distinct FirstFieldName, 'X' as Flag_Not_F
Where ThirdFieldName <> 'F'
Load Distinct FirstFieldName
Drop Field Flag_Not_F;
Hope this helps.
Please find the attached file and let me know if u have any problem
Ok I think we found some solutions. Give me some time to try them out and find out the best for me.
Two of them are using the MinString Funktion.
Are these solutions also working with other scenarios or only with E and F because E is alphabeticly smaller than F?