Forum Discussion
cap08
2 months agoNew Contributor III
This tool is great! Just wish it explained what the column names represented. I can figure out most of them except 'Fak', 'Lb', 'Tv' and 'Fx'.
- T_Kress2 months agoValued Contributor
Lb = the label field at the data source level. As far as the others I do not know. Maybe set up an adaptor SQL to pull top 1,000 rows from the view and see if the data in the view helps you understand those columns.
Here is SQL for a data adaptor, just be sure to limit it to top 1,000 or a particular time or WF name.
SELECT TOP (1000) [Wfk] ,[Wsk] ,[Wtk] ,[Fak] ,[Ri] ,[Rt] ,[Si] ,[Lb] ,[Tv] ,[Et] ,[EtT] ,[EtR] ,[Pr] ,[PrT] ,[PrR] ,[Cn] ,[CnT] ,[CnR] ,[Vw] ,[VwT] ,[VwR] ,[Sn] ,[SnT] ,[SnR] ,[Tm] ,[TmT] ,[TmR] ,[Ac] ,[AcT] ,[AcR] ,[Fw] ,[FwT] ,[FwR] ,[Og] ,[OgT] ,[OgR] ,[Ic] ,[IcT] ,[IcR] ,[U1] ,[U1T] ,[U1R] ,[U2] ,[U2T] ,[U2R] ,[U3] ,[U3T] ,[U3R] ,[U4] ,[U4T] ,[U4R] ,[U5] ,[U5T] ,[U5R] ,[U6] ,[U6T] ,[U6R] ,[U7] ,[U7T] ,[U7R] ,[U8] ,[U8T] ,[U8R] ,[Fs] ,[RawAmount] ,[ConvertedAmount] FROM [dbo].[vStageSourceAndTargetDataWithAttributes] WHERE TmT ='|WFTime|'
- MarcusH2 months agoValued Contributor
Do you mean Fs and not Fx? If so then that is FlipSign.
- cap082 months agoNew Contributor III
oh you're right - Fs - thanks
Related Content
- 10 months ago
- 10 months ago
- 2 years ago
- 10 months ago