Skip to Content

Mapping Question - create node if condition met

Im reading in a .csv file into a fcc. Im doing the mapping and i want to not create a new line if a condition is met.

1.png

I've go the below data to be mapped, but i only want to create a newhireline node if the department does not = C004

The issue is the C004 is embeded at the end of a string.

I've tried using Endswith and other if statements but i cant quite get it to ignore records with C004 and include all those that do not equal C004.

What would be the best way to approach this?

THanks

1.png (25.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 26, 2017 at 12:31 PM

    Hi George!

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2017 at 12:29 PM

    Hello George,

    If am not wrong your XML field value for Division should be like testcompany2(a004),testcompany2(C004),testcompany2(b002).

    Try the below approach

    Sample Input and Output:

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2017 at 01:35 PM

    Hi Evgeniy

    Ive tried that, but it doesnt seem to work, it still brings across records with (C004) in the text. Odd.

    I also was not aware i could bring all the other fields into the header mapping like that. See screen shots 1 & 2.

    1.png2.png

    Thanks

    George.

    Add comment
    10|10000 characters needed characters exceeded