data not updating as per the xcel sheet

[VSN]

I am uploading the data into project table, in my Excel states is Work in pending but after data loaded into the project table it showing as the Process State.

i tried with Onafter transform script  but not working and also used field level script . But still after loading the data into Snow it showing as the Project as :Process" state...

[SANDEEP28]

@VSN There might be a business rule or some logic is written which is changing status after importing data into project table. For first level of troubleshooting, uncheck "Run business rules" checkbox on transform map and then try to import the data again. 

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

[VSN]

If we disable the run business rules, project tasks won't be created.

[Robert H]

Hello @VSN ,

What do you mean by "Process" state? OOTB there is not Project state with that name.

The value of the "Work in Progress" state is 2.

What's the value in your Excel file, and what is your transform script doing? Please paste it here.

Regards,

Robert

[VSN]

In my excel state is work in progress, but after moving to target table it shows as pending state.