If have a project where i receive data in tables and a column is weather in kg or tons. I already changed the columns names so it is weather Poids_kg or Poids_tonnes, then, i need to change tons to kg but i can’t find how to use 2 different paths : one to divide data if it’s in tons (and change name to Poids_kg) and another to do nothing if it’s already in kg. I’ve tried differents switches but nothing worked.
I’m new to Knime and everything’s pretty hard to urderstand
The data is directly take from email attachements from clients and formated. But clients don’t always send csv with the same column order or type (i can have different type of informations).
That is the data i have at this point of my workflow (after remaming columns by type)
I have made a quick workflow to demonstrate using a case switch to detect the column name and then perform a conversion and rename of a column. I’m not sure if this exactly covers what you need to do, but hopefully it helps!