Forum Discussion

sgintowt's avatar
sgintowt
Helper I
4 years ago
Solved

conditional column

Hello,

 

I want to add a new column to my data marked "yes" or "no".

I have "table 1" with all the data and I have a second "table 2" imported to the data model with a selected customer list (ID) and cost type (Type).

Same as vlookup excel but with two conditions. The first is ID and the second is type.

So to add the column of selected customers to "table 1" with "table 2" marked "yes" or "no"

 

Table 1

 

IDUserIdDataPriceTypeTypeNettoTaxBruttoYes or NO
68899737124.11.2021nettoFK technologia62,84062,84 
68903207126.11.2021nettoFK technologia124,80124,8 
68890267124.11.2021nettoFK technologia460,820460,82 
6887224199926.11.2021nettoFK Remont127,50127,5 
68901307126.11.2021nettoFK Remont227495232,2727981,27 
38820587126.11.2021nettoFK Remont9020,7110,7 
6890379199924.11.2021nettoFK Remont2682,11616,893299 
3883647199926.11.2021nettoFK Remont474,32109,09583,41 
6890151199926.11.2021nettoFK technologia13,193,0316,22 
6890151199926.11.2021nettoFK technologia32,441,6234,06 
68872247126.11.2021nettoFK technologia501,690501,69 
68898147124.11.2021nettoFK koszty17017 
68878717124.11.2021nettoFK koszty2000200 
68898147124.11.2021nettoFK koszty17017 
6887224199926.11.2021nettoFK koszty141,330141,33 

 

 

Table 2

 

IDType
6889973FK technologia
6890320FK Remont
6889026FK technologia
6887224FK Remont
6890130FK technologia
3882058FK Remont

 

 

I added sample data.

I need to add the "yes or no" column to table 1 with clients who meet the "ID" and Type "conditions