BAQ Column Names

[dk8587 (Dan King)]

Hi all! I’m still getting my feet wet with BAQ in cloud-based Kinetic, and I have a question about column names of export excel files from BAQs. When I create a simple BAQ to display a table, the resulting output shows the user friendly column names (like Email Address, Phone Number), instead of the actual database names that DMT expects to see during imports (Like EmailAddress, PhoneNum). I can make a powershell script to loop through each of the excel files after they’ve been exported and do a search/replace on the column names, but is there an easier option inside BAQ studio to do this before the export is done?

EDIT: I may have answered my own question. Command line DMT has a -UseFieldNames option during BAQ exports to do this. I’ll try it out!

[Dnyanraj_Patil]

Simply specify the desired column label, and the result will include the label name.

[Shrivatsa_Melagiri]

Can we have Dynamic Label change , like accessing the name from other table and assigning to the current BAQ column name

I wanted to change the label column from above image dynamically

I want to access Table2.Name and assign that name ,Instead of value1

[NateS (Nate Schoonover)]

@Shrivatsa_Melagiri

Can we have Dynamic Label change , like accessing the name from other table and assigning to the current BAQ column name

There is not any way to dynamically assign labels in a BAQ that I know of.