Forum Discussion
Query editor replacing values based on another column
I am working with data involving manufacturing utilization from two sources, one table of just machine and scheduled hours, and another of machine, run hours, and some more classification columns suc...
HiAnonymous ,
1. When there is production data for a press then for the MFGCELL column is it always
"PLANT 5" if the value in the machine column is 0501-0556,
PLANT 1 if machine is 0101-0110 etc.
2. If this is the case , create a table with Machine and Plant like
0501, PLANT5
0502,PLANT5
0101,PLANT1
0110,PLANT1
3. Merge the first table with the second table on Machine and get the column value of Plant from second value.
If you upload sampledata, pbix to Google / One Drive and share the link may be I can help.
Cheers
CheenuSing