Announcements
When I get datatable from excel, how can i add column?
for example, dt={^[Name, Region],[Kim, Seoul],[Park, Busan]} and I want add a column named 'Age'
what should I do? Set Variable? Any other actions ??
As far as I know, you can't add a column to a table, unless you do it when you create it with "Create new data table".One solution could be to modify the excel sheet to include a column called age, and indclude this column when retriving data.
#Highboy Hmmm... That's what I expected. I think there are so many things to improve. Should I request these function to MS?
Hmmm... That's what I expected. I think there are so many things to improve. Should I request these function to MS?
You can always suggest, but don't get your hopes up too high.One of the rater simple but highly requested suggestions have been to get "colored comments" but they seem to ignore the fact that many people want it.
@bbjcar
As a workaround:
1. Open Excel
2. Add a column
3. Write the header in the first row
4. Read data from excel
5. Close excel with or without saving depending on your desired scenario
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 282 Super User 2026 Season 2
trice602 159 Super User 2026 Season 2
11manish 146 Super User 2026 Season 2
