Extra field in data upload

[MCmiranda]

Hi there,

Can someone push me in the right direction, or give me an example by telling me a solution?

So, I make an Excel export from a program and upload this to QS.
In this file I have 3 columns with different end dates. I need a new column with one absolute end date
based on the type of workorder it is.
For example:
When [workorder] = A, then copy the date from [date1] to a new field: [absolute end date]

I want to use this extra column/field in all my diagrams, not just in 1 table.

Hope I make myself clear..

If someone know a YouTube video for something like this, already a very big help!

[Ksrinivasan]

hi,

in your load script add this line

if([workorder] = 'A',date1,'') as [absolute end date]

ksrinivasan.

[MCmiranda]

Thank you!

Will this script add a column (the absolute end date column) if there is no current column with this name?

[Ksrinivasan]

hi,

yes, extra new column will add,

ksrinivasan

[MCmiranda]

The first comma is red, after that it is red shadow. Is it possible that I cannot use , ?