Extract sheet name and data from an excel.

I've an excel with two sheets. let's say sheetA & sheetB. SheetA and SheetB has some data. Both the sheet data has some connection.

I want to check whether SheetB is present or not. If it's not present, Create it with the data available in SheetA. means, for example, SheetA has 2 colums Firstname & Lastname. So the data in SheetB would be concatenated data of SheetA. that is. Firstname + Lastname.

So if SheetB is not present, take Firstname & Lastname from SheetA, and create SheetB with Firstname + Lastname

Any help?

-Krishna

What i tried is....

But the challenge I'm facing right now is, even if the SheetB is present, it'll create.

How can I block that? that is, if count !=0, the workflow should not execute further.

Workflow

Developer

Developer Tools

Error Message

Macros

Connectors

Best Practices

Bug

Batch Macro

Dynamic Processing

Expression

Documentation

Iterative Macro

Accepted answers

gabrielvilella

One way to not run an output tool is by enabling the option to Take table/file name from field. If there are zero records, the tool will not run.

Emmanuel_G

You're welcome @KrishnaChithrathil

You can find this test attached.

Let me know if it works as you want.

Create new sheet if missing with existing sheet_V2.yxzp

All comments

gabrielvilella

One way to not run an output tool is by enabling the option to Take table/file name from field. If there are zero records, the tool will not run.

KrishnaChithrathil

gabrielvilella,

I really appreciate the time you took to study my scenario. But I really didn't understand the solution you suggested to try out. Could you please be more specific on the point?

Krishna

gabrielvilella

See this example here, if there are no records, the output tool will not run.

File.yxmd

KrishnaChithrathil

gabrielvilella,

I went through the code you've provided.

Just have few doubts. What is the role of 'Fullpath' column there? Since we are filtering if Field1 = a, the result will be same without Fullpath column, right?

Please excuse and correct me if I'm wrong.

Emmanuel_G

Hi @KrishnaChithrathil ,

I did a test that you will find attached that does exactly what you want. It will create a tab if it does not exist and will contain the rows and columns of the tab that is present in your excel file.

You can test by adding sheet4, sheet5 as you want. You just need to provide name of desired adding sheet in column Sheet_missing as in workflow.

Let us know if it works the way you want.

Have a nice weekend !

Create new sheet if missing with existing sheet.yxzp

KrishnaChithrathil

Hey @Emmanuel_G

I really appreciate your effort. Thanks for that. I tried running your workflow. But in most of the tools, I couldn't see any output coming up. So I'm finding it difficult to understand.

I'm attaching an excel with this reply.

I've 2 sheets. SheetA & SheetB. Can you generate a workflow to check if SheetB is present or not. If it's not present, create SheetB through alteryx with values from SheetA. that is [First Name] + [Last Name].

Krishna

Book1.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703