Output Data in Same Excel Sheet according to Condition

[harshal98]

Have One Input Coming - If it comes with the data it should update the final excel sheet as it is with the data coming.

If No rows come in the Input data it should update value 'No Records Found' in  all the column and update it in the same excel sheet.Input with Data/rowsInput with no data/rowsOutput with data/rowsOutput with no data/rows

[Yoshiro_Fujimori]

Hi @harshal98 ,

I tried to add the row count to the original data to decide if "No Record" should be set or not.

But Append Field tool did not work for 0 record table. So I used Union tool instead.

There might be simpler solution...

Workflow

[harshal98]

Hi @Yoshiro_Fujimori ,

The Output to your solution is No Records Match but the output should have been the data as 2 rows are coming from the Input1, had there been no rows then it should have given the No Records Found Output.

Again - If data comes the output has to be the data as it is , If data / rows do not come then the output gives no records found.

So in actual case there will be only one input which either has data / rows or no data / rows. We have considered 2 inputs here as the solution should satisfy both the conditions.

[Yoshiro_Fujimori]

@harshal98 ,

I took the liberty of changing the Filter condition (to [RecordID] > 2), so that the T anchor should have no record.

If you change the condition to [RecordID] > 0 , the output would be as below;

So I think the above agrees with your statement below:

> Again - If data comes the output has to be the data as it is ,

> If data / rows do not come then the output gives no records found.