Dynamic Renaming Columns

Hi,

My Question is about how to ask user rename two mandatory columns.

What my app does: I want to fix/clean two columns (Date and Time), cuz most of the time these two columns are messy in field types and column names, and I want to use the app to standardize them. My app already has the function of how to clean up the Date and Time columns.

Question: Say a user input a file, his file has date and time column but they are not necessarily named in the correct way the app wants. The app could only clean columns named "Date" and named "Time", but if his file contains time column named "tIMe" or date column named "New date", it would not work.

I want to allow the user to choose the date column in his file, ask him to rename it to "Date", choose the time column in his file, ask him to rename it to "Time".

Also, the two columns his file has might not be the same field types my app could process. e.g. his Date column is a V-String but my app cleans Date column using Date as field type.

Thanks in advance.

Date Time

Accepted answers

TomWelgemoed

Apologies for the slow reply, was bedtime!

It's no problem - maybe the macro didn't export the way I expected it to. I'm trying to attach only the macro here - it's a really simple/basic setup meant to only prove the point, but hopefully it helps.

Regards,

Tom

Dynamic rename 2.yxzp

All comments

TomWelgemoed

Maybe it's better not to ask the user, but just to rename it yourself?

You can simply use a TitleCase statement in a Dynamic rename tool - see image below.

EDIT: Also attaching workflow.

Regards,

Tom

Dynamic rename 2.yxzp

TPYN

Hi Tom,

Thank you so much for the reply, i tried what you said and it works well in my workflow.

when I was trying to add interface, a problem occurs to me.

So previously, i was adding dropdown list to allow user choose the time and date column and rename it, but now since i enforce the dynamic rename with titlecase, should i change the action up to the dynamic rename other than the select function?

I mean, how will the user know if they should select time / date column when they upload the file?

Thanks so much.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703