Column Merge

[KamenRider]

Hi,

Can anyone help how I can merge this to look like this?

 

Hoping for anyone help and assistance.

Thanks,

Kamen

[KamenRider]

Hi @rzdodson 

What a fascinating work! Actually we are going away with excel macro. This design came from a macro excel and my purpose is to have Alteryx work everything. That is why I am hoping we can copy the input file I gave as the output with Alteryx so that we will no longer be pasting the results in the email but rather automating it. Is this possible?

Checking the excel file output, there are some error in the data wherein ULTRA MEGA should  covered Feb 6 to Feb 22. The results shows a lot of dates included which some suppose to be for XYZ Company. The branch names are missing and maybe you have incorporated this in the macro you are talking about.

See comparison below:

 

 

Hoping we could mirror the input file and results. Please advise.

Thanks,

Kamen

[rzdodson]

@KamenRider this should get you closer to what you are looking for.

I took the liberty of paring down the horizontal spread of the workflow by adding two standard macros in there for you: the blue one is a retooled data cleansing action based on your callout from your previous post; the second is just the Comp Sort logic to get the data back to what we are looking for the final output.

I went ahead and added a Block Until Done and Run Command combo to the workflow. In short, this will write the desired output to an xlsm file, and then the Run Command will kick in telling Alteryx to run the macro that is embedded in the xlsm file. Of note, Run Commands that are triggering other procedures can face some serious performance lag. In light of that, I am also linking some additional resources for you to keep in your back pocket.

Alteryx Knowledge Base Article: https://knowledge.alteryx.com/index/s/article/Alteryx-Run-Command-Executing-Excel-Macros-VBA-1583461...
Run Command instructional video: https://www.youtube.com/watch?v=k3RqxUc25ig

Hope that gets you closer! :)

[KamenRider]

Hi @rzdodson 

I have an error when I run the workflow. I think it is looking the vbs or scripts.

 

Please advise.

Kamen

[KamenRider]

Hi @rzdodson 

This is follow up the scripts. I think you have not attached it. The workflow is looking for the scripts.

Thanks,

Kamen

[rzdodson]

Attachment 1: VBS file that runs the VBA macro. This is the "KR Macro.vbs" file. You'll need to create a VBS file on your PC with this prompt in it.

Attachment 2: VBA macro file that gets called

[KamenRider]

HI @rzdodson 

I converted the text file to KR Macro.VBS however I am getting some error as shown below. Try some searching, but unable to locate some answers. Also I would like to ask where in the workflow I am going to use the KR Macro.txt?

Is it also possible to use a table tool as output where I could get also the output I wanted to be able to send to email?

 

I hope we have a solution for this. Please advise.

Thanks,

Kamen

 

[KamenRider]

HI @rzdodson

Just to follow up my inquiry and errors below.

Thanks,

Kamen

[KamenRider]

@rzdodson 

Can I ask for your assistance once again?

Thanks,

Kamen

[KamenRider]

Hi @rzdodson 

This is follow up my inquries.

Thanks,

Kamen