Forum Discussion

lboldrino's avatar
lboldrino
Icon for Resolver I rankResolver I
5 years ago
Solved

Create a new column from more columns other table

i have two tables_ fact_fahrzeuge: kennzeichen W12300 W12301 W12302 W12303 W12304 W12305 W12307   dim_sachkonto counter name position text bez 1 name1 W1230...
Need Help
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    Hi lboldrino 

     

    You can create a column with below code

     

    Column = 
CALCULATE(FIRSTNONBLANK(fact_fahrzeuge[kennzeichen],1),
FILTER(ALL(fact_fahrzeuge),CONTAINSSTRING(dim_sachkonto[bez],fact_fahrzeuge[kennzeichen]) || 
CONTAINSSTRING(dim_sachkonto[position],fact_fahrzeuge[kennzeichen]) ||
CONTAINSSTRING(dim_sachkonto[text],fact_fahrzeuge[kennzeichen])))

     

     

    Note:- W12305 it is not coming for me because its copied as  W!2305 in my data table. But it will works for you 🙂

    Thanks

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
5 years ago

What happens if Position = "W12300" and Text contains "W12301", etc?  Do you wan an Error Result if conflicting data in the columns, or do you want the columns to have an Success Order, ignoring the other columns if a result is found?

 

Forrest

  • lboldrino's avatar
    lboldrino
    Icon for Resolver I rankResolver I
    5 years ago

    What happens if Position = "W12300" and Text contains "W12301" - not possible. 

    but for example W12306 is not exist in dim_sackkonto, deshalb null