Append and replace the same output

Hi community,

I have two file below whereby one is orginal excel file and one is new data and would like to combine both data as below

Replacing Data.jpg

The orignal file name is " XYX" while Output also having the same file name " XYX".

The output of excel file will have the same file name as per original data. If there is new data found for the company code , then replacing the original data.

I have two struggle that i dont know how to solve it:

A. How to build the workflow so that the original file will not be affected until it has finished run and render the output fiel " XYX" as the file name for original file and output file is the same.

B. Secondly, how to incorporate the function so that if there is no original file exist yet then we just run the new data file and render it to the output file

Thank you in advance

Common Use Cases

Accepted answers

ed_hayter

I've re-saved the flow in a 2021 version hopefully you can load.

SH_APP.yxzp

All comments

ed_hayter

I would use a join to go about this.

If new information then overwrite otherwise add new information and keep unchanged information.

SH_Flow.yxmd

SH_94

Hi @ed_hayter ,

Currently you are using the text input , then it will not prompt the error,

As i using the excel file , xlsx, format , if the original file does not exist ( maybe deleted), it will prompt the error and we would like to know if there is no file found in the parituclar directory, we just skip it instead of prompt the error.

Thanks

ed_hayter

I've re-saved the flow in a 2021 version hopefully you can load.

SH_APP.yxzp

SH_94

Hi @ed_hayter ,

I have run the data and try to edit the control parameter few times but it prompt the error. May i know how to solve the error below?

Error

Error 1.png

Setting

Thank you for the assistance

ed_hayter

So you want to wrap the input in a container. Then attach the radio button for no original data to the lightning bolt of the container. When that button is clicked then the container turns off and that input file is never run.

Then you want to drag your second radio button for run with original data into the canvas without connecting it. This one should not update any value as the container is turned on by default and by virtue of pressing this button the other one must be off and therefore the container is active.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703