Share
Report
93A good afternoon,
I have a table(Table1), with 5 columns (col1,col2,col3,col4,col5)
In Col1 you have appel, peer, carrot
In Col2 you have cells that are empty and cell that are not
Now I want to get a new table : if Col1 = 'appel' and Col2 is empty then the new table (Table2) needs to have the following colums: Col1,Col2,Col4,Col5 if the above is not true then the new table2 needs to have the following Columns (Col1,Col2,Col3)
When I place in Col2 a fixed name or value then it runs, but I can't get the command to work with empy cell
I tried, Blank, Is Blank, Is empty
*******************************************************************
If ("appel" in Table1[@Col1] && IsBlank(Table1[@Col2]),
ClearCollect(Table2,
ShowColumns(Table1,"Col1","Col2","Col4","Col5")),
ClearCollect(Table2,
ShowColumns(Table2,"Col1","Col2","Col3"))));
************************************************************
if I change the IsBlank to the value or text that is in that column then it works
can you tell me what I am doing wrong
All responses (
Answers (
